package com.catering.mapper;

import com.catering.domain.Customer;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @author 86175
 * @description 针对表【customer(顾客表)】的数据库操作Mapper
 * @createDate 2024-10-23 10:54:07
 * @Entity com.catering.domain.Customer
 */
@Mapper
public interface CustomerMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Customer record);

    int insertSelective(Customer record);

    Customer selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Customer record);

    int updateByPrimaryKey(Customer record);

    //获取最新的顾客
    Customer selectLastMessage();

    //查询全部会员的方法
    List<Customer> queryMsgByVip();

    //查询全部的顾客信息
    List<Customer> queryAllCustomers();

    //根据id查询顾客信息
    Customer queryCustomer(Long id);

}
